Posts

Showing posts with the label Quick Data Entry

Do the Data Entry in your Excel WorkSheet in a right way!

Image
Introduction Let's admit that entering data in your worksheet manually is not fun. Mostly, you get your data from other database in CSV and TXT format which you then import in your sheet or you do the copy from one location and then paste in your worksheet. But sometimes, it becomes necessary to feed data manually to your worksheet before you can unleash the power of Excel. It may be noted that data entry is a slow process and, if done in haste, it becomes prone to errors especially if you have delegated the data entry work to your subordinates (in many organizations there are data entry operators for this type of work).  The Data Entry work requires constantly looking at the source material and then typing it in the designated Cell of your worksheet. In most cases, you type the contents of one cell and then press Enter or Tab to move Down or Right of your cell. In most cases, you want to move down in your Excel Worksheet in row by row manner (especially if your source material is